www.gusucode.com > 帝国网站管理系统(帝国CMS) 6 > 帝国网站管理系统(帝国CMS) 6.5繁体UTF-8/upload/e/admin/other/ListVoteMod.php
<?php
define('EmpireCMSAdmin','1');
require("../../class/connect.php");
require("../../class/db_sql.php");
require("../../class/functions.php");
require "../".LoadLang("pub/fun.php");
$link=db_connect();
$empire=new mysqlquery();
$editor=1;
//驗證用戶
$lur=is_login();
$logininid=$lur['userid'];
$loginin=$lur['username'];
$loginrnd=$lur['rnd'];
$loginlevel=$lur['groupid'];
$loginadminstyleid=$lur['adminstyleid'];
//驗證權限
CheckLevel($logininid,$loginin,$classid,"votemod");
//增加預設投票
function AddVoteMod($ysvotename,$title,$votename,$votenum,$delvid,$vid,$voteclass,$doip,$dotime,$width,$height,$tempid,$userid,$username){
global $empire,$dbtbpre;
if(!$ysvotename||!$tempid)
{
printerror("EmptyVoteTitle","history.go(-1)");
}
//返回組合
$votetext=ReturnVote($votename,$votenum,$delvid,$vid,0);
//統計總票數
for($i=0;$i<count($votename);$i++)
{
$t_votenum+=$votenum[$i];
}
$dotime=date("Y-m-d");
$t_votenum=(int)$t_votenum;
$voteclass=(int)$voteclass;
$width=(int)$width;
$height=(int)$height;
$doip=(int)$doip;
$tempid=(int)$tempid;
$sql=$empire->query("insert into {$dbtbpre}enewsvotemod(title,votetext,voteclass,doip,dotime,tempid,width,height,votenum,ysvotename) values('$title','$votetext',$voteclass,$doip,'$dotime',$tempid,$width,$height,$t_votenum,'$ysvotename');");
$voteid=$empire->lastid();
if($sql)
{
//操作日誌
insert_dolog("voteid=".$voteid."<br>title=".$title);
printerror("AddVoteSuccess","AddVoteMod.php?enews=AddVoteMod");
}
else
{
printerror("DbError","history.go(-1)");
}
}
//修改預設投票
function EditVoteMod($voteid,$ysvotename,$title,$votename,$votenum,$delvid,$vid,$voteclass,$doip,$dotime,$width,$height,$tempid,$userid,$username){
global $empire,$dbtbpre;
$voteid=(int)$voteid;
if(!$voteid||!$ysvotename||!$tempid)
{
printerror("EmptyVoteTitle","history.go(-1)");
}
//返回組合
$votetext=ReturnVote($votename,$votenum,$delvid,$vid,1);
//統計總票數
for($i=0;$i<count($votename);$i++)
{
$t_votenum+=$votenum[$i];
}
//處理變量
$t_votenum=(int)$t_votenum;
$voteclass=(int)$voteclass;
$width=(int)$width;
$height=(int)$height;
$doip=(int)$doip;
$tempid=(int)$tempid;
$sql=$empire->query("update {$dbtbpre}enewsvotemod set title='$title',votetext='$votetext',voteclass=$voteclass,doip=$doip,dotime='$dotime',tempid=$tempid,width=$width,height=$height,votenum=$t_votenum,ysvotename='$ysvotename' where voteid='$voteid'");
if($sql)
{
//操作日誌
insert_dolog("voteid=".$voteid."<br>title=".$title);
printerror("EditVoteSuccess","ListVoteMod.php");
}
else
{
printerror("DbError","history.go(-1)");
}
}
//刪除預設投票
function DelVoteMod($voteid,$userid,$username){
global $empire,$dbtbpre;
$voteid=(int)$voteid;
if(!$voteid)
{
printerror("NotDelVoteid","history.go(-1)");
}
$r=$empire->fetch1("select title from {$dbtbpre}enewsvotemod where voteid='$voteid'");
$sql=$empire->query("delete from {$dbtbpre}enewsvotemod where voteid='$voteid'");
if($sql)
{
//操作日誌
insert_dolog("voteid=".$voteid."<br>title=".$r[title]);
printerror("DelVoteSuccess","ListVoteMod.php");
}
else
{
printerror("DbError","history.go(-1)");
}
}
$enews=$_POST['enews'];
if(empty($enews))
{$enews=$_GET['enews'];}
//增加投票
if($enews=="AddVoteMod")
{
$title=$_POST['title'];
$votename=$_POST['votename'];
$votenum=$_POST['votenum'];
$delvid=$_POST['delvid'];
$vid=$_POST['vid'];
$voteclass=$_POST['voteclass'];
$doip=$_POST['doip'];
$dotime=$_POST['dotime'];
$width=$_POST['width'];
$height=$_POST['height'];
$tempid=$_POST['tempid'];
$ysvotename=$_POST['ysvotename'];
AddVoteMod($ysvotename,$title,$votename,$votenum,$delvid,$vid,$voteclass,$doip,$dotime,$width,$height,$tempid,$logininid,$loginin);
}
//修改投票
elseif($enews=="EditVoteMod")
{
$voteid=$_POST['voteid'];
$title=$_POST['title'];
$votename=$_POST['votename'];
$votenum=$_POST['votenum'];
$delvid=$_POST['delvid'];
$vid=$_POST['vid'];
$voteclass=$_POST['voteclass'];
$doip=$_POST['doip'];
$dotime=$_POST['dotime'];
$width=$_POST['width'];
$height=$_POST['height'];
$tempid=$_POST['tempid'];
$ysvotename=$_POST['ysvotename'];
EditVoteMod($voteid,$ysvotename,$title,$votename,$votenum,$delvid,$vid,$voteclass,$doip,$dotime,$width,$height,$tempid,$logininid,$loginin);
}
//刪除投票
elseif($enews=="DelVoteMod")
{
$voteid=$_GET['voteid'];
DelVoteMod($voteid,$logininid,$loginin);
}
$page=(int)$_GET['page'];
$start=0;
$line=20;//每頁顯示條數
$page_line=12;//每頁顯示鏈接數
$offset=$page*$line;//總偏移量
$query="select voteid,ysvotename,title,voteclass from {$dbtbpre}enewsvotemod";
$num=$empire->num($query);//取得總條數
$query=$query." order by voteid desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page2($num,$line,$page_line,$start,$page,$search);
$url="<a href=ListVoteMod.php>管理預設投票</a>";
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>投票</title>
<link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td width="50%">位置:
<?=$url?>
</td>
<td><div align="right">
<input type="button" name="Submit5" value="增加預設投票" onclick="self.location.href='AddVoteMod.php?enews=AddVoteMod';">
</div></td>
</tr>
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr class="header">
<td width="10%" height="25"><div align="center">ID</div></td>
<td width="43%" height="25"><div align="center">投票名稱</div></td>
<td width="18%" height="25"><div align="center">類型</div></td>
<td width="29%" height="25"><div align="center">操作</div></td>
</tr>
<?
while($r=$empire->fetch($sql))
{
$voteclass=empty($r['voteclass'])?'單選':'多選';
?>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">
<?=$r[voteid]?>
</div></td>
<td height="25">
<?=$r[ysvotename]?>
</td>
<td height="25"><div align="center">
<?=$voteclass?>
</div></td>
<td height="25"><div align="center">[<a href="AddVoteMod.php?enews=EditVoteMod&voteid=<?=$r[voteid]?>">修改</a>]
[<a href="ListVoteMod.php?enews=DelVoteMod&voteid=<?=$r[voteid]?>" onclick="return confirm('確認要刪除?');">刪除</a>]</div></td>
</tr>
<?
}
?>
<tr bgcolor="#FFFFFF">
<td height="25" colspan="4">
<?=$returnpage?>
</td>
</tr>
</table>
</body>
</html>
<?
db_close();
$empire=null;
?>